USE MASTER
GO

-- Create an empty database

CREATE DATABASE Secure
GO

USE Secure
GO

-- Create three schemas

CREATE SCHEMA Sales
GO
CREATE SCHEMA Marketing
GO
CREATE SCHEMA Research
GO

-- Create a table in each

CREATE TABLE Sales.Customer   (ID int, Name nvarchar(50))
CREATE TABLE Marketing.Lead   (ID int, Name nvarchar(50))
CREATE TABLE Research.Project (ID int, Name nvarchar(50))

-- !Check schemas and tables in Object Explorer

-- Create a table without specifying a schema

CREATE TABLE Products         (ID int, Name nvarchar(50))

-- !Check table's schema in Object Explorer

-- Done

USE MASTER
GO

-- DROP DATABASE Secure
-- GO
